Problem Note 44935: A "File does not exist" error might be issued when trying to read a transport file with the XPORT LIBNAME engine
A transport file that can be read using the SAS Viewer might produce error messages like the following when you are trying to convert the file to a SAS data set using PROC COPY with the XPORT LIBNAME engine:
NOTE: Input library TEST is sequential.
NOTE: Copying TEST.MYSAS to WORK.MYSAS (memtype=DATA).
ERROR: File TEST.MYSAS does not exist.
ERROR: File WORK.MYSAS has not been saved because copy could not be completed.
NOTE: Statements not processed because of errors noted above.
NOTE: PROCEDURE COPY used (Total process time):
real time 0.40 seconds
cpu time 0.06 seconds
NOTE: The SAS System stopped processing this step because of errors.
These errors are most likely to occur when the transport file contains a table with the name in mixed case.
To circumvent the problem, do one of the following:
- If you do not have many tables, you can edit the files manually and change the table names to upper case.
- You can programmatically modify the table name. The sample program below reads in the file one byte at a time to find the area of the file (199x...207x hexadecimal area) that contains the table name, and changes it to upper case.
data _null_;
infile 'c:\trans.xpt' recfm=f lrecl=1;
file 'c:\trans.xpt' recfm=f lrecl=1;
input x $char1.;
if 199x <= _n_ < 207x then x=upcase(x);
put x $char1.;
run;
Operating System and Release Information
SAS System | Base SAS | Microsoft Windows Server 2008 for x64 | | 9.3 TS1M2 |
Microsoft Windows XP Professional | | 9.3 TS1M2 |
Windows 7 Enterprise 32 bit | | 9.3 TS1M2 |
Windows 7 Enterprise x64 | | 9.3 TS1M2 |
Windows 7 Home Premium 32 bit | | 9.3 TS1M2 |
Windows 7 Home Premium x64 | | 9.3 TS1M2 |
Windows 7 Professional 32 bit | | 9.3 TS1M2 |
Windows 7 Professional x64 | | 9.3 TS1M2 |
Windows 7 Ultimate 32 bit | | 9.3 TS1M2 |
Microsoft Windows Server 2008 | | 9.3 TS1M2 |
Microsoft Windows Server 2003 for x64 | | 9.3 TS1M2 |
Microsoft Windows Server 2003 Standard Edition | | 9.3 TS1M2 |
OS/2 | | |
Microsoft Windows 95/98 | | |
Microsoft Windows 2000 Advanced Server | | |
Microsoft Windows 2000 Datacenter Server | | |
Microsoft Windows 2000 Server | | |
Microsoft Windows 2000 Professional | | |
Microsoft Windows NT Workstation | | |
Microsoft Windows Server 2003 Datacenter Edition | | 9.3 TS1M2 |
Microsoft Windows Server 2003 Enterprise Edition | | 9.3 TS1M2 |
Microsoft® Windows® for x64 | | 9.3 TS1M2 |
Microsoft Windows XP 64-bit Edition | | 9.3 TS1M2 |
Microsoft Windows Server 2003 Enterprise 64-bit Edition | | 9.3 TS1M2 |
Microsoft Windows Server 2003 Datacenter 64-bit Edition | | 9.3 TS1M2 |
Microsoft® Windows® for 64-Bit Itanium-based Systems | | 9.3 TS1M2 |
Z64 | | 9.3 TS1M2 |
z/OS | | 9.3 TS1M2 |
OpenVMS VAX | | 9.3 TS1M2 |
Windows 7 Ultimate x64 | | 9.3 TS1M2 |
Windows Millennium Edition (Me) | | |
Windows Vista | | 9.3 TS1M2 |
Windows Vista for x64 | | 9.3 TS1M2 |
64-bit Enabled AIX | | 9.3 TS1M2 |
64-bit Enabled HP-UX | | 9.3 TS1M2 |
64-bit Enabled Solaris | | 9.3 TS1M2 |
ABI+ for Intel Architecture | | 9.3 TS1M2 |
AIX | | 9.3 TS1M2 |
HP-UX | | 9.3 TS1M2 |
HP-UX IPF | | 9.3 TS1M2 |
IRIX | | 9.3 TS1M2 |
Linux | | 9.3 TS1M2 |
Linux for x64 | | 9.3 TS1M2 |
Linux on Itanium | | 9.3 TS1M2 |
OpenVMS Alpha | | 9.3 TS1M2 |
OpenVMS on HP Integrity | | 9.3 TS1M2 |
Solaris | | 9.3 TS1M2 |
Solaris for x64 | | 9.3 TS1M2 |
Tru64 UNIX | | 9.3 TS1M2 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
A transport file that can be read using the SAS Viewer might produce an error when you are trying to convert the file to a SAS data set. The error indicates that the file does not exist. This SAS Note offers two solutions.
Type: | Problem Note |
Priority: | medium |
Date Modified: | 2011-11-30 11:18:13 |
Date Created: | 2011-11-22 19:16:28 |